comparing Dates vs text date

[Wilco()]

Hi

I am trying to test if month is a month.

In column A I have list of a dates entered

In column B I have converted the dates in A to just the month (Jan, Feb, etc), by using format cell: Date (custom: mmm)

In column C I have a money value.

I want to count for each month the total money value. So I build a new table, containing 2 columns;

A: Jan, Feb, Mar, etc (text!!)

B: there would the calculation go to total each month

I cannot compare the table row A with column B as it would be comparing text to a date number. And that will never match. So how can I do this?

 

[bobhc]

If you convert the data in to a table you can then filter on any month and get the total for those months

 

[Wilco()]

I want to display the value on a different sheet.

Besides now I am working with this issue, I want a better understanding of how to work with dates. So I want a solution

 

[Vishal Srivastava]

Hi

I am trying to test if month is a month.

In column A I have list of a dates entered

In column B I have converted the dates in A to just the month (Jan, Feb, etc), by using format cell: Date (custom: mmm)

In column C I have a money value.

I want to count for each month the total money value. So I build a new table, containing 2 columns;

A: Jan, Feb, Mar, etc (text!!)

B: there would the calculation go to total each month

I cannot compare the table row A with column B as it would be comparing text to a date number. And that will never match. So how can I do this?

Hi,
Suppose Your text date is in a cell B2.

Try this =TEXT(B2,"dd/mm/yyyy")

And use you regular function.

Hope It will help you!

Thanks & Regards,
CMA Vishal Srivastava

 

[Somendra Misra]

Hi Wilco(),

You have option of pivot tables also to summaries sales month wise.

Or else consider uploading a sample file.

Regards,

 

[Wilco()]

@Somendra, I though of Pivot table as well. That might have worked. Now I just was curious how I could tackle this without Pivot.

@Vishal, that is exactly what I need to handle dates. Thanks!

 

[Vishal Srivastava]

@Somendra, I though of Pivot table as well. That might have worked. Now I just was curious how I could tackle this without Pivot.

@Vishal, that is exactly what I need to handle dates. Thanks!

You are Welcome!