# Excel Formula Clarification

Closed
Shonky - Jul 3, 2009 at 11:02 PM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Aug 20, 2010 at 09:04 AM
Hi Guys and Gals,

Is there a formula that can make the value of any given cell always display the 1st day of the current month?

I am aware of the =NOW() function but I just need the cell to display the 1st day and hold that value up until the next 1st day of the next month

eg. 1 July

This cell must hold this value for the month.
Then at 00:00 on the 1st of August that same cell would automatically give a value of

1 Aug

Any ideas would be greatly appreciated.

Cheers,

Sean.
Related:

## 3 responses

Excelguru Posts 261 Registration date Saturday April 11, 2009 Status Member Last seen June 21, 2011 307
Jul 4, 2009 at 12:37 AM
Hi Shonky

Try =DATE(YEAR(NOW()),MONTH(NOW()),1)
That's Brilliant!!

Exactly what I needed!

Thanks Heaps Excelguru!
Hi,

I need excel doubt....

00:05:00
00:06:00
00:10:22
00:10:30
00:13:43
00:14:07
00:20:43
00:20:50
00:26:56
00:40:41
00:43:13
01:40:11

I need clarification for the time variance

1. Less than < 5 Mins
2. 6-15 mins
3. 16-30 mins
4. 31-60 mins
5. > 1hr

How to calculation apply to the formula....
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Aug 20, 2010 at 09:04 AM
and how are you calcualting this variance ? Your question, at least to me, seems to be incomplete