Excel Formula ClarificationClosed

Question

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.

Excelguru · Answer

Hi Shonky

Try =DATE(YEAR(NOW()),MONTH(NOW()),1)

Shonky · Answer

That's Brilliant!!

Exactly what I needed!

Thanks Heaps Excelguru!

remo · Answer

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....

Excel Formula Clarification

3 responses

Similar discussions

Subscribe To Our Newsletter!