Search : in
By :

Excel Formula Clarification

Last answer on Jul 4, 2009 9:01:34 am BST Shonky, on Jul 4, 2009 4:02:10 am BST 
 Report this message to moderators

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.

Configuration: Excel 2003

Best answers for « Excel Formula Clarification » in :
Basic Excel Formulas ShowBasic Excel Formulas Below are some basic formulas for Microsoft excel: Basic formula : ADDITION cell A1 to A10 = sum (A1: A10) AVERAGE cell A1 to A10 = average (A1: A10) MAXIMUM cell A1 to A10 = max (A1: A10) MINIMUM...
Avoid duplicates in Excel ShowAvoid duplicates in Excel In order to avoid duplication when encoding in a column from an excel sheet: take the conditional format on the first cell under the headings (eg A2) choose the following formula:...
[Excel] Adding a fixed date in a cell Show[Excel] Adding a fixed date in a cell If you want to insert the current date in a cell in following format DD /MM/YYYY, and that it remains unchanged, without being updated each time the file is opened. Simply type "ctrl" + ";" in the...
Spreadsheet - Formulas ShowIntroduction to Formulas The main use of a spreadsheet is to automate calculations, which means using cells to perform operations based on values in other cells. The spreadsheet recalculates all the values each time a change is made to the value of...
Spreadsheets - Conditional expressions ShowWhat is a Conditional Structure? Conditional structures are instructions that allow to test if a condition is true or not. Conditional structures may be associated together. To successfully execute these tests using logical functions, spreadsheets...
Ask your question Reply

1

Excelguru, on Jul 4, 2009 5:37:11 am BST

Hi Shonky

Try =DATE(YEAR(NOW()),MONTH(NOW()),1) Winners are losers who got up and gave it one more try. -Den­nis DeYoung
My Interests are financial Modelling and custom excel develo­pment.

   
Reply to Excelguru

2

 Shonky, on Jul 4, 2009 9:01:34 am BST

That's Brilliant!!

Exactly what I needed!

Thanks Heaps Excelguru!

   
Reply to Shonky
Ask your question Reply
They need your help