Excel Formula Clarification

Closed
Shonky - Jul 3, 2009 at 11:02 PM
rizvisa1
Posts
4479
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.

3 replies

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)
0
That's Brilliant!!

Exactly what I needed!

Thanks Heaps Excelguru!
0
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....
0
rizvisa1
Posts
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
769
Aug 20, 2010 at 09:04 AM
and how are you calcualting this variance ? Your question, at least to me, seems to be incomplete
0