Excel Formula Clarification [Closed]

Report
-
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
-
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.

3 replies

Posts
261
Registration date
Saturday April 11, 2009
Status
Member
Last seen
June 21, 2011
307
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....
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
and how are you calcualting this variance ? Your question, at least to me, seems to be incomplete

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!